SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:42 HIGHBRIDGE- Sited in one of the most desirable locales in Lyme, this stunning reproduction colonial is nestled on 21.30 private acres with gorgeous northerly views. The interiors are bright and well-appointed with a sizable chef's kitchen that steps down into a formal dining room surrounded by windows and a walk-out to the landscaped grounds and gardens. Adjoining the kitchen and dining room is an expansive living room with wood-burning fireplace which opens through French doors to a lovely covered porch/patio and in-ground swimming pool. Rounding out the first floor is a light-filled office to the front of the house and a functional laundry/mudroom entry from the breezeway to the attached two-car garage. An en suite primary bedroom with wood-burning stove on the second floor is complemented by two additional bedrooms with a shared bath, while a versatile open space on the uppermost level is perfectly suited for a rec room or additional living space. Above the garage is a generously-sized accessory studio with a kitchenette, bath, and its own private entry. The renovated sugar shack is incredible (+ approx. 285 sf). The grounds are a lovely mixture of landscaped gardens, lawns and curated mixed forest, all of which overlooks the gorgeous long-range vistas. Located minutes from downtown Lyme and a short drive from Hanover, Dartmouth College, and area schools, this property offers the convenience of proximity coupled with the luxury of privacy. Some photos virtually staged.
Description:DEER RUN- This rarest of estates is comprised of 177+ pristine south-facing acres with beautiful long-range views only minutes from downtown Hanover and Dartmouth College. The elegant federal reproduction house is spacious and well-appointed with premium finish work and attention to detail at every turn. A large open concept kitchen with eat-in dining and family space on the east side of the main level flows effortlessly onto a flagstone patio for entertaining and enjoying the landscaped views. On the west side of the main level is a formal dining room, grand living room, and cozy library. The second floor features a substantial and luxurious primary suite with bathroom, private dressing area/office, and a sizable walk-in closet. There are four additional bedrooms on this level, two of which are en suite while the other east-facing rooms share a bathroom. Rounding out the interiors is a versatile lower walkout level, perfect for a den, media room, or recreation space. The exteriors of the property are equally as stunning, with a geometric cobblestone driveway approaching the house and detached 3-bay garage, mature landscaped flower beds, stone walls, fenced vegetable garden, and separate barn for equipment, toys, and storage. Above the garage is a guest space with its own bedroom and bath. Enjoy miles of trails throughout the land component, perfect for walks, snow-shoeing/skiing, and an assortment of recreational activities.